﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PeygirDatabaseDataSet" targetNamespace="http://tempuri.org/PeygirDatabaseDataSet.xsd" xmlns:mstns="http://tempuri.org/PeygirDatabaseDataSet.xsd" xmlns="http://tempuri.org/PeygirDatabaseDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="PeygirDatabaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="PeygirDatabaseConnectionString (Settings)" PropertyReference="ApplicationSettings.Peygir.Data.Properties.Settings.GlobalReference.Default.PeygirDatabaseConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AttachmentsTableAdapter" GeneratorDataComponentClassName="AttachmentsTableAdapter" Name="Attachments" UserDataComponentName="AttachmentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Attachments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Attachments` (`TicketID`, `Name`, `Size`, `Contents`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Size" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Contents" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Contents" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, TicketID, Name, [Size], Contents FROM Attachments</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="TicketID" DataSetColumn="TicketID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Size" DataSetColumn="Size" />
              <Mapping SourceColumn="Contents" DataSetColumn="Contents" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteByID" Modifier="Public" Name="DeleteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="DeleteByID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Attachments
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Attachments" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Attachments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Contents, ID, Name, [Size], TicketID FROM Attachments WHERE (ID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Attachments" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Attachments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTicketID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTicketID" GeneratorSourceName="FillByTicketID" GetMethodModifier="Public" GetMethodName="GetDataByTicketID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTicketID" UserSourceName="FillByTicketID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Contents, ID, Name, [Size], TicketID FROM Attachments WHERE (TicketID = ?) ORDER BY TicketID, Name, ID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="TicketID" DataSourceName="Attachments" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetID" Modifier="Public" Name="GetID" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(ID) FROM Attachments
WHERE TicketID = ? AND Name = ?  AND [Size] = ?
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="TicketID" DataSourceName="Attachments" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Name" DataSourceName="Attachments" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Size" DataSourceName="Attachments" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Size" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateByID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE Attachments SET TicketID = ?, [Name] = ?, [Size] = ?, Contents = ?
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="TicketID" DataSourceName="Attachments" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Name" DataSourceName="Attachments" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Size" DataSourceName="Attachments" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Size" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="Contents" DataSourceName="Attachments" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Contents" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Contents" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param5" ColumnName="ID" DataSourceName="Attachments" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MilestonesTableAdapter" GeneratorDataComponentClassName="MilestonesTableAdapter" Name="Milestones" UserDataComponentName="MilestonesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Milestones" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Milestones` (`ProjectID`, `Name`, `Description`, `State`, `DisplayOrder`) VALUES (?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ProjectID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="State" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="DisplayOrder" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, ProjectID, Name, Description, State, DisplayOrder FROM Milestones</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ProjectID" DataSetColumn="ProjectID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="DisplayOrder" DataSetColumn="DisplayOrder" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteByID" Modifier="Public" Name="DeleteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="DeleteByID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Milestones
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Milestones" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Description, DisplayOrder, ID, Name, ProjectID, State FROM Milestones WHERE (ID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Milestones" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProjectID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectID" GeneratorSourceName="FillByProjectID" GetMethodModifier="Public" GetMethodName="GetDataByProjectID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectID" UserSourceName="FillByProjectID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Description, DisplayOrder, ID, Name, ProjectID, State FROM Milestones WHERE (ProjectID = ?) ORDER BY DisplayOrder, Name, ID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="ProjectID" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ProjectID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetID" Modifier="Public" Name="GetID" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(ID) FROM Milestones
WHERE ProjectID = ? AND Name = ? AND Description = ? AND State = ? AND DisplayOrder = ?
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="ProjectID" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ProjectID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Name" DataSourceName="Milestones" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Description" DataSourceName="Milestones" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="State" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="State" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="DisplayOrder" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="DisplayOrder" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetMaxDisplayOrder" Modifier="Public" Name="GetMaxDisplayOrder" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetMaxDisplayOrder">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(DisplayOrder) FROM (SELECT DisplayOrder FROM Milestones WHERE ProjectID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="" DataSourceName="" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Param1" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateByID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE Milestones SET ProjectID = ?, Name = ?, Description = ?, State = ?, DisplayOrder = ?
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="ProjectID" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ProjectID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Name" DataSourceName="Milestones" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Description" DataSourceName="Milestones" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="State" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="State" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="DisplayOrder" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="DisplayOrder" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param6" ColumnName="ID" DataSourceName="Milestones" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProjectsTableAdapter" GeneratorDataComponentClassName="ProjectsTableAdapter" Name="Projects" UserDataComponentName="ProjectsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Projects" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Projects` (`Name`, `Description`, `DisplayOrder`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="DisplayOrder" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, Description, DisplayOrder FROM Projects</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="DisplayOrder" DataSetColumn="DisplayOrder" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteByID" Modifier="Public" Name="DeleteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="DeleteByID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Projects
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Projects" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Projects" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Description, DisplayOrder, ID, Name FROM Projects WHERE (ID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Projects" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetID" Modifier="Public" Name="GetID" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(ID) FROM Projects
WHERE Name = ? AND Description = ? AND DisplayOrder = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Name" DataSourceName="Projects" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Description" DataSourceName="Projects" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="DisplayOrder" DataSourceName="Projects" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="DisplayOrder" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetMaxDisplayOrder" Modifier="Public" Name="GetMaxDisplayOrder" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetMaxDisplayOrder">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(DisplayOrder) FROM Projects</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateByID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE Projects SET Name = ?, Description = ?, DisplayOrder = ?
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Name" DataSourceName="Projects" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Description" DataSourceName="Projects" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="DisplayOrder" DataSourceName="Projects" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="DisplayOrder" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DisplayOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param4" ColumnName="ID" DataSourceName="Projects" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TicketsTableAdapter" GeneratorDataComponentClassName="TicketsTableAdapter" Name="Tickets" UserDataComponentName="TicketsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Tickets" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Tickets` (`MilestoneID`, `TicketNumber`, `Summary`, `ReportedBy`, `Type`, `Severity`, `State`, `AssignedTo`, `Priority`, `Description`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="MilestoneID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MilestoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="TicketNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Summary" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ReportedBy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ReportedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Severity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Severity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="State" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AssignedTo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AssignedTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Priority" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, MilestoneID, TicketNumber, Summary, ReportedBy, Type, Severity, State, AssignedTo, Priority, Description FROM Tickets</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="MilestoneID" DataSetColumn="MilestoneID" />
              <Mapping SourceColumn="TicketNumber" DataSetColumn="TicketNumber" />
              <Mapping SourceColumn="Summary" DataSetColumn="Summary" />
              <Mapping SourceColumn="ReportedBy" DataSetColumn="ReportedBy" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Severity" DataSetColumn="Severity" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="AssignedTo" DataSetColumn="AssignedTo" />
              <Mapping SourceColumn="Priority" DataSetColumn="Priority" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteByID" Modifier="Public" Name="DeleteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="DeleteByID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Tickets WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Tickets" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AssignedTo, Description, ID, MilestoneID, Priority, ReportedBy, Severity, State, Summary, TicketNumber, Type FROM Tickets WHERE (ID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Tickets" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByMilestoneID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByMilestoneID" GeneratorSourceName="FillByMilestoneID" GetMethodModifier="Public" GetMethodName="GetDataByMilestoneID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByMilestoneID" UserSourceName="FillByMilestoneID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AssignedTo, Description, ID, MilestoneID, Priority, ReportedBy, Severity, State, Summary, TicketNumber, Type FROM Tickets WHERE (MilestoneID = ?) ORDER BY TicketNumber DESC, ID DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="MilestoneID" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="MilestoneID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MilestoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="Tickets" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProjectID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectID" GeneratorSourceName="FillByProjectID" GetMethodModifier="Public" GetMethodName="GetDataByProjectID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectID" UserSourceName="FillByProjectID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AssignedTo, Description, ID, MilestoneID, Priority, ReportedBy, Severity, State, Summary, TicketNumber, Type FROM Tickets WHERE (MilestoneID IN (SELECT ID FROM Milestones WHERE (ProjectID = ?))) ORDER BY TicketNumber DESC, ID DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="" DataSourceName="" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Param1" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetID" Modifier="Public" Name="GetID" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(ID) FROM Tickets
WHERE MilestoneID = ? AND TicketNumber = ? AND Summary = ? AND ReportedBy = ? AND Type = ? AND Severity = ? AND State = ? AND AssignedTo = ? AND Priority = ? AND Description = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="MilestoneID" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="MilestoneID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MilestoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="TicketNumber" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Summary" DataSourceName="Tickets" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Summary" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="ReportedBy" DataSourceName="Tickets" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="ReportedBy" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="ReportedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="Type" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="Severity" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Severity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Severity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="State" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="State" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="AssignedTo" DataSourceName="Tickets" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="AssignedTo" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="AssignedTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="Priority" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Priority" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="Description" DataSourceName="Tickets" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetMaxTicketNumber" Modifier="Public" Name="GetMaxTicketNumber" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetMaxTicketNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(TicketNumber) FROM (SELECT TicketNumber FROM Tickets WHERE MilestoneID IN (SELECT ID FROM Milestones WHERE ProjectID = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="" DataSourceName="" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Param1" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateByID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE Tickets SET MilestoneID = ?, TicketNumber = ?, Summary = ?, ReportedBy = ?, Type = ?, Severity = ?, State = ?, AssignedTo = ?, Priority = ?, Description = ?
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="MilestoneID" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="MilestoneID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MilestoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="TicketNumber" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Summary" DataSourceName="Tickets" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Summary" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="ReportedBy" DataSourceName="Tickets" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="ReportedBy" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="ReportedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="Type" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="Severity" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Severity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Severity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="State" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="State" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="AssignedTo" DataSourceName="Tickets" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="AssignedTo" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="AssignedTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="Priority" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Priority" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="Description" DataSourceName="Tickets" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param11" ColumnName="ID" DataSourceName="Tickets" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TicketsHistoryTableAdapter" GeneratorDataComponentClassName="TicketsHistoryTableAdapter" Name="TicketsHistory" UserDataComponentName="TicketsHistoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="TicketsHistory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `TicketsHistory` (`TicketID`, `Timestamp`, `Changes`, `Comment`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Timestamp" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Changes" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Changes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Comment" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, TicketID, [Timestamp], Changes, Comment FROM TicketsHistory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="TicketID" DataSetColumn="TicketID" />
              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
              <Mapping SourceColumn="Changes" DataSetColumn="Changes" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteByID" Modifier="Public" Name="DeleteByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="DeleteByID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM TicketsHistory
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="TicketsHistory" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="TicketsHistory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Changes, Comment, ID, TicketID, [Timestamp] FROM TicketsHistory WHERE (ID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="TicketsHistory" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="TicketsHistory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTicketID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTicketID" GeneratorSourceName="FillByTicketID" GetMethodModifier="Public" GetMethodName="GetDataByTicketID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTicketID" UserSourceName="FillByTicketID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Changes, Comment, ID, TicketID, [Timestamp] FROM TicketsHistory WHERE (TicketID = ?) ORDER BY ID DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="TicketID" DataSourceName="TicketsHistory" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetID" Modifier="Public" Name="GetID" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(ID) FROM TicketsHistory
WHERE TicketID = ? AND [Timestamp] = ? AND Changes = ? AND Comment = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="TicketID" DataSourceName="TicketsHistory" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Timestamp" DataSourceName="TicketsHistory" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="Timestamp" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Changes" DataSourceName="TicketsHistory" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Changes" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Changes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="Comment" DataSourceName="TicketsHistory" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Comment" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateByID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE TicketsHistory SET TicketID = ?, [Timestamp] = ?, Changes = ?, Comment = ?
WHERE ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="TicketID" DataSourceName="TicketsHistory" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Timestamp" DataSourceName="TicketsHistory" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="Timestamp" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Changes" DataSourceName="TicketsHistory" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Changes" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Changes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="Comment" DataSourceName="TicketsHistory" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Comment" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param5" ColumnName="ID" DataSourceName="TicketsHistory" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AttachmentsWithoutContentsTableAdapter" GeneratorDataComponentClassName="AttachmentsWithoutContentsTableAdapter" Name="AttachmentsWithoutContents" UserDataComponentName="AttachmentsWithoutContentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="AttachmentsWithoutContents" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, TicketID, Name, [Size] FROM AttachmentsWithoutContents</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="TicketID" DataSetColumn="TicketID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Size" DataSetColumn="Size" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="AttachmentsWithoutContents" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByTicketID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTicketID" GeneratorSourceName="FillByTicketID" GetMethodModifier="Public" GetMethodName="GetDataByTicketID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTicketID" UserSourceName="FillByTicketID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, TicketID, Name, [Size] FROM AttachmentsWithoutContents
WHERE (TicketID = ?)
ORDER BY TicketID, Name, ID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="TicketID" DataSourceName="AttachmentsWithoutContents" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="TicketID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TicketID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TicketAssigneesTableAdapter" GeneratorDataComponentClassName="TicketAssigneesTableAdapter" Name="TicketAssignees" UserDataComponentName="TicketAssigneesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="TicketAssignees" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Assignee FROM TicketAssignees</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Assignee" DataSetColumn="Assignee" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TicketReportersTableAdapter" GeneratorDataComponentClassName="TicketReportersTableAdapter" Name="TicketReporters" UserDataComponentName="TicketReportersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PeygirDatabaseConnectionString (Settings)" DbObjectName="TicketReporters" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Reporter FROM TicketReporters</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Reporter" DataSetColumn="Reporter" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PeygirDatabaseDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="PeygirDatabaseDataSet" msprop:Generator_UserDSName="PeygirDatabaseDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Attachments" msprop:Generator_TableClassName="AttachmentsDataTable" msprop:Generator_TableVarName="tableAttachments" msprop:Generator_RowChangedName="AttachmentsRowChanged" msprop:Generator_TablePropName="Attachments" msprop:Generator_RowDeletingName="AttachmentsRowDeleting" msprop:Generator_RowChangingName="AttachmentsRowChanging" msprop:Generator_RowEvHandlerName="AttachmentsRowChangeEventHandler" msprop:Generator_RowDeletedName="AttachmentsRowDeleted" msprop:Generator_RowClassName="AttachmentsRow" msprop:Generator_UserTableName="Attachments" msprop:Generator_RowEvArgName="AttachmentsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="TicketID" msprop:Generator_ColumnVarNameInTable="columnTicketID" msprop:Generator_ColumnPropNameInRow="TicketID" msprop:Generator_ColumnPropNameInTable="TicketIDColumn" msprop:Generator_UserColumnName="TicketID" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Size" msprop:Generator_ColumnVarNameInTable="columnSize" msprop:Generator_ColumnPropNameInRow="Size" msprop:Generator_ColumnPropNameInTable="SizeColumn" msprop:Generator_UserColumnName="Size" type="xs:int" minOccurs="0" />
              <xs:element name="Contents" msprop:Generator_ColumnVarNameInTable="columnContents" msprop:Generator_ColumnPropNameInRow="Contents" msprop:Generator_ColumnPropNameInTable="ContentsColumn" msprop:Generator_UserColumnName="Contents" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Milestones" msprop:Generator_TableClassName="MilestonesDataTable" msprop:Generator_TableVarName="tableMilestones" msprop:Generator_RowChangedName="MilestonesRowChanged" msprop:Generator_TablePropName="Milestones" msprop:Generator_RowDeletingName="MilestonesRowDeleting" msprop:Generator_RowChangingName="MilestonesRowChanging" msprop:Generator_RowEvHandlerName="MilestonesRowChangeEventHandler" msprop:Generator_RowDeletedName="MilestonesRowDeleted" msprop:Generator_RowClassName="MilestonesRow" msprop:Generator_UserTableName="Milestones" msprop:Generator_RowEvArgName="MilestonesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="ProjectID" msprop:Generator_ColumnVarNameInTable="columnProjectID" msprop:Generator_ColumnPropNameInRow="ProjectID" msprop:Generator_ColumnPropNameInTable="ProjectIDColumn" msprop:Generator_UserColumnName="ProjectID" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State" type="xs:int" minOccurs="0" />
              <xs:element name="DisplayOrder" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder" msprop:Generator_ColumnPropNameInRow="DisplayOrder" msprop:Generator_ColumnPropNameInTable="DisplayOrderColumn" msprop:Generator_UserColumnName="DisplayOrder" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Projects" msprop:Generator_TableClassName="ProjectsDataTable" msprop:Generator_TableVarName="tableProjects" msprop:Generator_RowChangedName="ProjectsRowChanged" msprop:Generator_TablePropName="Projects" msprop:Generator_RowDeletingName="ProjectsRowDeleting" msprop:Generator_RowChangingName="ProjectsRowChanging" msprop:Generator_RowEvHandlerName="ProjectsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProjectsRowDeleted" msprop:Generator_RowClassName="ProjectsRow" msprop:Generator_UserTableName="Projects" msprop:Generator_RowEvArgName="ProjectsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayOrder" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder" msprop:Generator_ColumnPropNameInRow="DisplayOrder" msprop:Generator_ColumnPropNameInTable="DisplayOrderColumn" msprop:Generator_UserColumnName="DisplayOrder" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tickets" msprop:Generator_TableClassName="TicketsDataTable" msprop:Generator_TableVarName="tableTickets" msprop:Generator_RowChangedName="TicketsRowChanged" msprop:Generator_TablePropName="Tickets" msprop:Generator_RowDeletingName="TicketsRowDeleting" msprop:Generator_RowChangingName="TicketsRowChanging" msprop:Generator_RowEvHandlerName="TicketsRowChangeEventHandler" msprop:Generator_RowDeletedName="TicketsRowDeleted" msprop:Generator_RowClassName="TicketsRow" msprop:Generator_UserTableName="Tickets" msprop:Generator_RowEvArgName="TicketsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="MilestoneID" msprop:Generator_ColumnVarNameInTable="columnMilestoneID" msprop:Generator_ColumnPropNameInRow="MilestoneID" msprop:Generator_ColumnPropNameInTable="MilestoneIDColumn" msprop:Generator_UserColumnName="MilestoneID" type="xs:int" minOccurs="0" />
              <xs:element name="TicketNumber" msprop:Generator_ColumnVarNameInTable="columnTicketNumber" msprop:Generator_ColumnPropNameInRow="TicketNumber" msprop:Generator_ColumnPropNameInTable="TicketNumberColumn" msprop:Generator_UserColumnName="TicketNumber" type="xs:int" minOccurs="0" />
              <xs:element name="Summary" msprop:Generator_ColumnVarNameInTable="columnSummary" msprop:Generator_ColumnPropNameInRow="Summary" msprop:Generator_ColumnPropNameInTable="SummaryColumn" msprop:Generator_UserColumnName="Summary" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReportedBy" msprop:Generator_ColumnVarNameInTable="columnReportedBy" msprop:Generator_ColumnPropNameInRow="ReportedBy" msprop:Generator_ColumnPropNameInTable="ReportedByColumn" msprop:Generator_UserColumnName="ReportedBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type" type="xs:int" minOccurs="0" />
              <xs:element name="Severity" msprop:Generator_ColumnVarNameInTable="columnSeverity" msprop:Generator_ColumnPropNameInRow="Severity" msprop:Generator_ColumnPropNameInTable="SeverityColumn" msprop:Generator_UserColumnName="Severity" type="xs:int" minOccurs="0" />
              <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State" type="xs:int" minOccurs="0" />
              <xs:element name="AssignedTo" msprop:Generator_ColumnVarNameInTable="columnAssignedTo" msprop:Generator_ColumnPropNameInRow="AssignedTo" msprop:Generator_ColumnPropNameInTable="AssignedToColumn" msprop:Generator_UserColumnName="AssignedTo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" msprop:Generator_UserColumnName="Priority" type="xs:int" minOccurs="0" />
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TicketsHistory" msprop:Generator_TableClassName="TicketsHistoryDataTable" msprop:Generator_TableVarName="tableTicketsHistory" msprop:Generator_RowChangedName="TicketsHistoryRowChanged" msprop:Generator_TablePropName="TicketsHistory" msprop:Generator_RowDeletingName="TicketsHistoryRowDeleting" msprop:Generator_RowChangingName="TicketsHistoryRowChanging" msprop:Generator_RowEvHandlerName="TicketsHistoryRowChangeEventHandler" msprop:Generator_RowDeletedName="TicketsHistoryRowDeleted" msprop:Generator_RowClassName="TicketsHistoryRow" msprop:Generator_UserTableName="TicketsHistory" msprop:Generator_RowEvArgName="TicketsHistoryRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="TicketID" msprop:Generator_ColumnVarNameInTable="columnTicketID" msprop:Generator_ColumnPropNameInRow="TicketID" msprop:Generator_ColumnPropNameInTable="TicketIDColumn" msprop:Generator_UserColumnName="TicketID" type="xs:int" minOccurs="0" />
              <xs:element name="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" msprop:Generator_UserColumnName="Timestamp" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Changes" msprop:Generator_ColumnVarNameInTable="columnChanges" msprop:Generator_ColumnPropNameInRow="Changes" msprop:Generator_ColumnPropNameInTable="ChangesColumn" msprop:Generator_UserColumnName="Changes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AttachmentsWithoutContents" msprop:Generator_TableClassName="AttachmentsWithoutContentsDataTable" msprop:Generator_TableVarName="tableAttachmentsWithoutContents" msprop:Generator_RowChangedName="AttachmentsWithoutContentsRowChanged" msprop:Generator_TablePropName="AttachmentsWithoutContents" msprop:Generator_RowDeletingName="AttachmentsWithoutContentsRowDeleting" msprop:Generator_RowChangingName="AttachmentsWithoutContentsRowChanging" msprop:Generator_RowEvHandlerName="AttachmentsWithoutContentsRowChangeEventHandler" msprop:Generator_RowDeletedName="AttachmentsWithoutContentsRowDeleted" msprop:Generator_RowClassName="AttachmentsWithoutContentsRow" msprop:Generator_UserTableName="AttachmentsWithoutContents" msprop:Generator_RowEvArgName="AttachmentsWithoutContentsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="TicketID" msprop:Generator_ColumnVarNameInTable="columnTicketID" msprop:Generator_ColumnPropNameInRow="TicketID" msprop:Generator_ColumnPropNameInTable="TicketIDColumn" msprop:Generator_UserColumnName="TicketID" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Size" msprop:Generator_ColumnVarNameInTable="columnSize" msprop:Generator_ColumnPropNameInRow="Size" msprop:Generator_ColumnPropNameInTable="SizeColumn" msprop:Generator_UserColumnName="Size" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TicketAssignees" msprop:Generator_TableClassName="TicketAssigneesDataTable" msprop:Generator_TableVarName="tableTicketAssignees" msprop:Generator_RowChangedName="TicketAssigneesRowChanged" msprop:Generator_TablePropName="TicketAssignees" msprop:Generator_RowDeletingName="TicketAssigneesRowDeleting" msprop:Generator_RowChangingName="TicketAssigneesRowChanging" msprop:Generator_RowEvHandlerName="TicketAssigneesRowChangeEventHandler" msprop:Generator_RowDeletedName="TicketAssigneesRowDeleted" msprop:Generator_RowClassName="TicketAssigneesRow" msprop:Generator_UserTableName="TicketAssignees" msprop:Generator_RowEvArgName="TicketAssigneesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Assignee" msprop:Generator_ColumnVarNameInTable="columnAssignee" msprop:Generator_ColumnPropNameInRow="Assignee" msprop:Generator_ColumnPropNameInTable="AssigneeColumn" msprop:Generator_UserColumnName="Assignee" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TicketReporters" msprop:Generator_TableClassName="TicketReportersDataTable" msprop:Generator_TableVarName="tableTicketReporters" msprop:Generator_RowChangedName="TicketReportersRowChanged" msprop:Generator_TablePropName="TicketReporters" msprop:Generator_RowDeletingName="TicketReportersRowDeleting" msprop:Generator_RowChangingName="TicketReportersRowChanging" msprop:Generator_RowEvHandlerName="TicketReportersRowChangeEventHandler" msprop:Generator_RowDeletedName="TicketReportersRowDeleted" msprop:Generator_RowClassName="TicketReportersRow" msprop:Generator_UserTableName="TicketReporters" msprop:Generator_RowEvArgName="TicketReportersRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Reporter" msprop:Generator_ColumnVarNameInTable="columnReporter" msprop:Generator_ColumnPropNameInRow="Reporter" msprop:Generator_ColumnPropNameInTable="ReporterColumn" msprop:Generator_UserColumnName="Reporter" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Attachments" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Milestones_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Milestones" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Projects_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Projects" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Tickets_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tickets" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TicketsHistory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TicketsHistory" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="AttachmentsWithoutContents_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AttachmentsWithoutContents" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="TicketsAttachments" msdata:parent="Tickets" msdata:child="Attachments" msdata:parentkey="ID" msdata:childkey="TicketID" msprop:Generator_UserChildTable="Attachments" msprop:Generator_ChildPropName="GetAttachmentsRows" msprop:Generator_UserRelationName="TicketsAttachments" msprop:Generator_ParentPropName="TicketsRow" msprop:Generator_RelationVarName="relationTicketsAttachments" msprop:Generator_UserParentTable="Tickets" />
      <msdata:Relationship name="ProjectsMilestones" msdata:parent="Projects" msdata:child="Milestones" msdata:parentkey="ID" msdata:childkey="ProjectID" msprop:Generator_UserChildTable="Milestones" msprop:Generator_ChildPropName="GetMilestonesRows" msprop:Generator_UserRelationName="ProjectsMilestones" msprop:Generator_ParentPropName="ProjectsRow" msprop:Generator_RelationVarName="relationProjectsMilestones" msprop:Generator_UserParentTable="Projects" />
      <msdata:Relationship name="MilestonesTickets" msdata:parent="Milestones" msdata:child="Tickets" msdata:parentkey="ID" msdata:childkey="MilestoneID" msprop:Generator_UserChildTable="Tickets" msprop:Generator_ChildPropName="GetTicketsRows" msprop:Generator_UserRelationName="MilestonesTickets" msprop:Generator_RelationVarName="relationMilestonesTickets" msprop:Generator_UserParentTable="Milestones" msprop:Generator_ParentPropName="MilestonesRow" />
      <msdata:Relationship name="TicketsTicketsHistory" msdata:parent="Tickets" msdata:child="TicketsHistory" msdata:parentkey="ID" msdata:childkey="TicketID" msprop:Generator_UserChildTable="TicketsHistory" msprop:Generator_ChildPropName="GetTicketsHistoryRows" msprop:Generator_UserRelationName="TicketsTicketsHistory" msprop:Generator_RelationVarName="relationTicketsTicketsHistory" msprop:Generator_UserParentTable="Tickets" msprop:Generator_ParentPropName="TicketsRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>